<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LocationDataSet" targetNamespace="http://tempuri.org/LocationDataSet.xsd" xmlns:mstns="http://tempuri.org/LocationDataSet.xsd" xmlns="http://tempuri.org/LocationDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SocialNetworkConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="SocialNetworkConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WLQuickApps.SocialNetwork.Data.Properties.Settings.GlobalReference.Default.SocialNetworkConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocationTableAdapter" GeneratorDataComponentClassName="LocationTableAdapter" Name="Location" UserDataComponentName="LocationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Location" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT Location.LocationID, Name, Address1, Address2, City, Region, Country, PostalCode, Latitude, Longitude, Type
FROM dbo.Location</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LocationID" DataSetColumn="LocationID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Address1" DataSetColumn="Address1" />
              <Mapping SourceColumn="Address2" DataSetColumn="Address2" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="Region" DataSetColumn="Region" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="PostalCode" DataSetColumn="PostalCode" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longitude" DataSetColumn="Longitude" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="CreateLocation" Modifier="Public" Name="CreateLocation" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="CreateLocation">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DECLARE @locationID UNIQUEIDENTIFIER;
SELECT @locationID = NEWID();

INSERT INTO [dbo].[Location] ([LocationID], [Name], [Address1], [Address2], [City], [Region], [Country], [PostalCode], Latitude, Longitude, Type) VALUES (@locationID, @name, @address1, @address2, @city, @region, @country, @postalCode, @latitude, @longitude, @type);

SELECT @locationID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="Name" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="address1" ColumnName="Address1" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@address1" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Address1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="address2" ColumnName="Address2" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@address2" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Address2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="city" ColumnName="City" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="region" ColumnName="Region" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@region" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Region" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="country" ColumnName="Country" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@country" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="postalCode" ColumnName="PostalCode" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(16)" DbType="AnsiString" Direction="Input" ParameterName="@postalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="16" SourceColumn="PostalCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="latitude" ColumnName="Latitude" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@latitude" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="Latitude" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="longitude" ColumnName="Longitude" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@longitude" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="Longitude" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="type" ColumnName="Type" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Location" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetNamedLocations" GetMethodModifier="Public" GetMethodName="GetNamedLocations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetNamedLocations" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>WITH PageTable AS (SELECT        LocationID, Name, Address1, Address2, City, Region, Country, PostalCode, Latitude, Longitude, ROW_NUMBER() OVER (ORDER BY LocationID)
 AS RowID
FROM            dbo.Location
WHERE        (Name LIKE @name ESCAPE '!') AND DATALENGTH(Type) &gt; 0)
    SELECT        *
     FROM            PageTable
     WHERE        RowID BETWEEN (@startRowIndex + 1) AND (@startRowIndex + @maximumRows)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="Name" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Location" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetLocationByLocationID" GetMethodModifier="Public" GetMethodName="GetLocationByLocationID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetLocationByLocationID" UserSourceName="GetLocationByLocationID1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT Address1, Address2, City, Country, Latitude, LocationID, Longitude, Name, PostalCode, Region, Type FROM Location WHERE (LocationID = @locationID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="locationID" ColumnName="LocationID" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@locationID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="LocationID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="GetNamedLocationsCount" Modifier="Public" Name="GetNamedLocationsCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="GetNamedLocationsCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COUNT(*) FROM Location
WHERE        (Name LIKE @name ESCAPE '!') AND DATALENGTH(Type) &gt; 0</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="Name" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Location" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="LookupLocation" GetMethodModifier="Public" GetMethodName="LookupLocation" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="LookupLocation" UserSourceName="LookupLocation1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT Address1, Address2, City, Country, Latitude, LocationID, Longitude, Name, PostalCode, Region, Type FROM Location WHERE (Name LIKE @name) AND (Address1 = @address1) AND (Address2 = @address2) AND (City = @city) AND (Region = @region) AND (Country = @country) AND (PostalCode = @postalCode) AND (Type = @type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="Name" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="address1" ColumnName="Address1" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@address1" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Address1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="address2" ColumnName="Address2" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@address2" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Address2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="city" ColumnName="City" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="region" ColumnName="Region" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@region" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Region" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="country" ColumnName="Country" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@country" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="postalCode" ColumnName="PostalCode" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(16)" DbType="AnsiString" Direction="Input" ParameterName="@postalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="16" SourceColumn="PostalCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="type" ColumnName="Type" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(64)" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="SearchLocations" GetMethodModifier="Public" GetMethodName="SearchLocations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="SearchLocations" UserSourceName="SearchLocations1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>WITH PageTable AS (SELECT        LocationID, Name, Address1, Address2, City, Region, Country, PostalCode, Latitude, Longitude, ROW_NUMBER() OVER (ORDER BY LocationID)
 AS RowID
FROM            dbo.Location
WHERE        SearchData LIKE @locationSearchData AND DATALENGTH(Type) &gt; 0)
    SELECT        *
     FROM            PageTable
     WHERE        RowID BETWEEN (@startRowIndex + 1) AND (@startRowIndex + @maximumRows)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="searchData" ColumnName="SearchData" DataSourceName="" DataTypeServer="varchar(256)" DbType="AnsiString" Direction="Input" ParameterName="@locationSearchData" Precision="0" ProviderType="VarChar" Scale="0" Size="256" SourceColumn="SearchData" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="SearchLocationsCount" Modifier="Public" Name="SearchLocationsCount" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="SearchLocationsCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COUNT(*)
FROM dbo.Location
WHERE SearchData like @locationSearchData
AND DATALENGTH(Type) &gt; 0</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="locationSearchData" ColumnName="SearchData" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(256)" DbType="AnsiString" Direction="Input" ParameterName="@locationSearchData" Precision="0" ProviderType="VarChar" Scale="0" Size="256" SourceColumn="SearchData" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="SetSearchHint" Modifier="Public" Name="SetSearchHint" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="SetSearchHint">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE       Location
SET                SearchData = @searchData
where LocationID = @locationID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="searchData" ColumnName="SearchData" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="varchar(256)" DbType="AnsiString" Direction="Input" ParameterName="@searchData" Precision="0" ProviderType="VarChar" Scale="0" Size="256" SourceColumn="SearchData" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="locationID" ColumnName="LocationID" DataSourceName="SocialNetwork.dbo.Location" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@locationID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="LocationID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LocationDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="LocationDataSet" msprop:Generator_DataSetName="LocationDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Location" msprop:Generator_UserTableName="Location" msprop:Generator_RowDeletedName="LocationRowDeleted" msprop:Generator_RowChangedName="LocationRowChanged" msprop:Generator_RowClassName="LocationRow" msprop:Generator_RowChangingName="LocationRowChanging" msprop:Generator_RowEvArgName="LocationRowChangeEvent" msprop:Generator_RowEvHandlerName="LocationRowChangeEventHandler" msprop:Generator_TableClassName="LocationDataTable" msprop:Generator_TableVarName="tableLocation" msprop:Generator_RowDeletingName="LocationRowDeleting" msprop:Generator_TablePropName="Location">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LocationID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="LocationID" msprop:Generator_ColumnPropNameInRow="LocationID" msprop:Generator_ColumnVarNameInTable="columnLocationID" msprop:Generator_ColumnPropNameInTable="LocationIDColumn" type="xs:string" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address1" msprop:Generator_UserColumnName="Address1" msprop:Generator_ColumnPropNameInRow="Address1" msprop:Generator_ColumnVarNameInTable="columnAddress1" msprop:Generator_ColumnPropNameInTable="Address1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address2" msprop:Generator_UserColumnName="Address2" msprop:Generator_ColumnPropNameInRow="Address2" msprop:Generator_ColumnVarNameInTable="columnAddress2" msprop:Generator_ColumnPropNameInTable="Address2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Region" msprop:Generator_UserColumnName="Region" msprop:Generator_ColumnPropNameInRow="Region" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_ColumnPropNameInTable="RegionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostalCode" msprop:Generator_UserColumnName="PostalCode" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnPostalCode" msprop:Generator_ColumnPropNameInTable="PostalCodeColumn" msprop:Generator_ColumnPropNameInRow="PostalCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" />
              <xs:element name="Longitude" msprop:Generator_UserColumnName="Longitude" msprop:Generator_ColumnVarNameInTable="columnLongitude" msprop:Generator_ColumnPropNameInRow="Longitude" msprop:Generator_ColumnPropNameInTable="LongitudeColumn" type="xs:double" />
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Location" />
      <xs:field xpath="mstns:LocationID" />
    </xs:unique>
  </xs:element>
</xs:schema>